Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
InventoryControlDocumentID (FK)(PK) | The reference number that uniquely identifies the InventoryControlDocument. | ID_ICD | Identity | integer | InventoryControlDocument(DO_ICD) |
InventoryControlDocumentLineItemID (PK) | A unique system assigned identifier for the LineItem within the confines of the InventoryControlDocument. | IC_LTM_ICD | LineNumber | smallint | |
RelativeOrder | A retailer assigned relative order number, showing the relative order of this LineItem with respect to the other LineItems in the InventoryControlDocument. This allows the retailer to modifiy the order of LineItems within the context of the InventoryControlDocument - during it's life-cycle. | AI_RL_ORD | LineNumber | smallint | |
LineItemTypeCode | The DOCUMENT LINE ITEM CODE TYPE CODE specifies the item type. | TY_ITM_DCM_LN | Code2 | char(2) | |